Solution to Exercise 1

Solution to exercise 1.

We'll cover the following

Solution#

Explanation#

Nothing too tricky going on here. All we need to do is use the COUNT() function to get the number of employees and in the WHERE clause, specify the project we are interested in i.e., P1. The slides below provide a visual representation of the solution:

Created with Fabric.js 1.6.0-rc.1 The WHERE clause will return those records where Project = P1 The COUNT() function will then simply count the number of records returned,which in this case is 2.
Exercise 1
Exercise 2
Mark as Completed
Report an Issue